rollback segment造句
例句与造句
- recreate the rollback tablespace with all of its rollback segments
用它的所有回滚段重新创建回滚表空间。 - create few additional rollback segments to handle the database activities
创建少数附加回滚段来处理数据库活动。 - a rollback segment is only online until the instance is shut down
直到实例关闭后,回滚段才联机。不明白什么意思。 - the database was not cleanly shut down there are active transactions in the rollback segments
数据库没有彻底关闭(在回滚段中有活动的事务)。 - recovering from the loss of a data file that belongs to a traditional rollback segment tablespace
从属于传统回滚段表空间的数据文件的丢失中恢复。 - It's difficult to find rollback segment in a sentence. 用rollback segment造句挺难的
- in oracle 9i, oracle introduced the undo tablespace concept, which replaces the rollback segment
在oracle9i中,oracle引入了undo表空间概念,这取代了回滚段。 - for online backup, special care needs to be taken for the system table space and rollback segments table space
对于联机备份,需要特别注意system表空间和回滚段表空间。 - using objects known as rollback segments, oracle constructs read-consistent views of data as of the point in time a sql statement is issued
oracle使用名为“回滚段”的对象在发出sql语句的时间点处构造读取一致数据视图。 - prior to oracle 9i, the recommended method of reducing the frequency of this error was to increase the size and or number of rollback segments, and to assign large transactions to a specific rollback segment
在oracle9i之前的版本中,推荐使用增加回滚段的大小和/或数量,并将较大事务分配给特定的回滚段来降低此错误的出现频率。 - prior to oracle 9i, the recommended method of reducing the frequency of this error was to increase the size and or number of rollback segments, and to assign large transactions to a specific rollback segment
在oracle9i之前的版本中,推荐使用增加回滚段的大小和/或数量,并将较大事务分配给特定的回滚段来降低此错误的出现频率。 - oracle online recovery depends a great deal on what is actually lost, for example, losing a group on online redo logs, losing a rollback segment data file, or corrumption of a data file for the system table space
oracle联机恢复很大程度上取决于实际丢失了什么,例如,在联机重做日志上丢失了一个组、丢失了回滚段数据文件或者system表空间的数据文件的损坏。 - in order to tune memory we describe how to improve the sharing for memory; and the tuning for i / o mainly includes decreasing the contention of i / o by reasonable distribution of physical and logical strcture, adjusting the storing of data, and the optimizing for rollback segment and redo log . the tuning of application programs mainly includes the optimizing of sql, this paper describes how to excute sql trace and explain plan to get the estimate for the effect of the excution of sql, and then put forward some tips for tuning sql . while discussing the tuning of os and network, this paper emphasizes how to increase the resource serving for database by reducing the resource taking up by other applications, and how to improve the performance of network by reducing the flow on network
内存的优化主要是通过如何提高内存的共享来实现的;系统i/o的优化,则主要通过对数据库物理和逻辑结构的合理分布、数据的合理存储、以及对回滚段和重做日志调整的阐述,说明如何达到减少i/o争用的目的;应用系统的优化则主要是sql语句的优化,本文通过说明如何执行sql跟踪和解释计划从而获得对sql语句实际执行效果的评价,同时还给出sql语句优化的一些常用技巧;在讨论对操作系统和网络的优化时,本文着重介绍了如何减少其它应用所占用的资源,从而增大为数据库服务的资源,以及如何通过减少网络流量的方法来提高网络性能等方面加以阐述。